/****** Object:  Table [dbo].[aspnet_PersonalizationAllUsers]    Script Date: 05/04/2010 00:30:41 ******/
DELETE FROM [dbo].[aspnet_PersonalizationAllUsers]
GO
/****** Object:  Table [dbo].[aspnet_Profile]    Script Date: 05/04/2010 00:30:41 ******/
DELETE FROM [dbo].[aspnet_Profile]
GO
/****** Object:  Table [dbo].[QuestionVotes]    Script Date: 05/04/2010 00:30:41 ******/
DELETE FROM [dbo].[QuestionVotes]
GO
/****** Object:  Table [dbo].[aspnet_Membership]    Script Date: 05/04/2010 00:30:41 ******/
DELETE FROM [dbo].[aspnet_Membership]
GO
/****** Object:  Table [dbo].[aspnet_PersonalizationPerUser]    Script Date: 05/04/2010 00:30:41 ******/
DELETE FROM [dbo].[aspnet_PersonalizationPerUser]
GO
/****** Object:  Table [dbo].[aspnet_Paths]    Script Date: 05/04/2010 00:30:41 ******/
DELETE FROM [dbo].[aspnet_Paths]
GO
/****** Object:  Table [dbo].[aspnet_UsersInRoles]    Script Date: 05/04/2010 00:30:41 ******/
DELETE FROM [dbo].[aspnet_UsersInRoles]
GO
/****** Object:  Table [dbo].[aspnet_Roles]    Script Date: 05/04/2010 00:30:41 ******/
DELETE FROM [dbo].[aspnet_Roles]
GO
/****** Object:  Table [dbo].[AnswerVotes]    Script Date: 05/04/2010 00:30:41 ******/
DELETE FROM [dbo].[AnswerVotes]
GO
/****** Object:  Table [dbo].[Answers]    Script Date: 05/04/2010 00:30:41 ******/
DELETE FROM [dbo].[Answers]
GO
/****** Object:  Table [dbo].[UserDetails]    Script Date: 05/04/2010 00:30:41 ******/
DELETE FROM [dbo].[UserDetails]
GO
/****** Object:  Table [dbo].[FavouriteQuestions]    Script Date: 05/04/2010 00:30:41 ******/
DELETE FROM [dbo].[FavouriteQuestions]
GO
/****** Object:  Table [dbo].[Questions]    Script Date: 05/04/2010 00:30:41 ******/
DELETE FROM [dbo].[Questions]
GO
/****** Object:  Table [dbo].[aspnet_Users]    Script Date: 05/04/2010 00:30:41 ******/
DELETE FROM [dbo].[aspnet_Users]
GO
/****** Object:  Table [dbo].[aspnet_Applications]    Script Date: 05/04/2010 00:30:41 ******/
DELETE FROM [dbo].[aspnet_Applications]
GO
/****** Object:  Table [dbo].[aspnet_WebEvent_Events]    Script Date: 05/04/2010 00:30:41 ******/
DELETE FROM [dbo].[aspnet_WebEvent_Events]
GO
/****** Object:  Table [dbo].[aspnet_SchemaVersions]    Script Date: 05/04/2010 00:30:41 ******/
DELETE FROM [dbo].[aspnet_SchemaVersions]
GO

/******* INSERTS ***************/
/****** Object:  Table [dbo].[aspnet_Applications]    Script Date: 05/09/2010 00:55:59 ******/
INSERT [dbo].[aspnet_Applications] ([ApplicationName], [LoweredApplicationName], [ApplicationId], [Description]) VALUES (N'/', N'/', N'43178882-5efc-4c03-a556-a05ba9c9c727', NULL)
/****** Object:  Table [dbo].[aspnet_SchemaVersions]    Script Date: 05/09/2010 00:55:59 ******/
INSERT [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'common', N'1', 1)
INSERT [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'health monitoring', N'1', 1)
INSERT [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'membership', N'1', 1)
INSERT [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'personalization', N'1', 1)
INSERT [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'profile', N'1', 1)
INSERT [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'role manager', N'1', 1)
/****** Object:  Table [dbo].[aspnet_WebEvent_Events]    Script Date: 05/09/2010 00:55:59 ******/
/****** Object:  Table [dbo].[aspnet_Users]    Script Date: 05/09/2010 00:55:59 ******/
INSERT [dbo].[aspnet_Users] ([ApplicationId], [UserId], [UserName], [LoweredUserName], [MobileAlias], [IsAnonymous], [LastActivityDate]) VALUES (N'43178882-5efc-4c03-a556-a05ba9c9c727', N'f39661f2-a3bd-47a4-899f-38c71e35c738', N'test', N'test', NULL, 0, CAST(0x00009D70016929A8 AS DateTime))
INSERT [dbo].[aspnet_Users] ([ApplicationId], [UserId], [UserName], [LoweredUserName], [MobileAlias], [IsAnonymous], [LastActivityDate]) VALUES (N'43178882-5efc-4c03-a556-a05ba9c9c727', N'83666688-5998-45a8-82d4-28f517ae3945', N'test2', N'test2', NULL, 0, CAST(0x00009D700168B61D AS DateTime))
/****** Object:  Table [dbo].[aspnet_Paths]    Script Date: 05/09/2010 00:55:59 ******/
/****** Object:  Table [dbo].[aspnet_Roles]    Script Date: 05/09/2010 00:55:59 ******/
INSERT [dbo].[aspnet_Roles] ([ApplicationId], [RoleId], [RoleName], [LoweredRoleName], [Description]) VALUES (N'43178882-5efc-4c03-a556-a05ba9c9c727', N'5b6f6322-8743-4da4-a29f-30ddea42bae7', N'Moderator', N'moderator', NULL)
INSERT [dbo].[aspnet_Roles] ([ApplicationId], [RoleId], [RoleName], [LoweredRoleName], [Description]) VALUES (N'43178882-5efc-4c03-a556-a05ba9c9c727', N'f59cc23f-64ba-4f24-a082-27b3a6e0a0ce', N'User', N'user', NULL)
/****** Object:  Table [dbo].[aspnet_Membership]    Script Date: 05/09/2010 00:55:59 ******/
INSERT [dbo].[aspnet_Membership] ([ApplicationId], [UserId], [Password], [PasswordFormat], [PasswordSalt], [MobilePIN], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [IsApproved], [IsLockedOut], [CreateDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPasswordAttemptWindowStart], [FailedPasswordAnswerAttemptCount], [FailedPasswordAnswerAttemptWindowStart], [Comment]) VALUES (N'43178882-5efc-4c03-a556-a05ba9c9c727', N'f39661f2-a3bd-47a4-899f-38c71e35c738', N'XSI3kQRATfi8jxCA5RlBtV//jes=', 1, N'aN8bkrwKg30qHLs7gkJckA==', NULL, N'test@test.com', N'test@test.com', NULL, NULL, 1, 0, CAST(0x00009D7001674DA4 AS DateTime), CAST(0x00009D700168F18D AS DateTime), CAST(0x00009D7001674DA4 AS DateTime), CAST(0xFFFF2FB300000000 AS DateTime), 0, CAST(0xFFFF2FB300000000 AS DateTime), 0, CAST(0xFFFF2FB300000000 AS DateTime), NULL)
INSERT [dbo].[aspnet_Membership] ([ApplicationId], [UserId], [Password], [PasswordFormat], [PasswordSalt], [MobilePIN], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [IsApproved], [IsLockedOut], [CreateDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPasswordAttemptWindowStart], [FailedPasswordAnswerAttemptCount], [FailedPasswordAnswerAttemptWindowStart], [Comment]) VALUES (N'43178882-5efc-4c03-a556-a05ba9c9c727', N'83666688-5998-45a8-82d4-28f517ae3945', N'v2MdzBPkbBKTx7dba8/pXkqMdso=', 1, N'iXZhIBrWQ5dZLnll5OIhcQ==', NULL, N'test2@test.com', N'test2@test.com', NULL, NULL, 1, 0, CAST(0x00009D700167FC40 AS DateTime), CAST(0x00009D700167FC40 AS DateTime), CAST(0x00009D700167FC40 AS DateTime), CAST(0xFFFF2FB300000000 AS DateTime), 0, CAST(0xFFFF2FB300000000 AS DateTime), 0, CAST(0xFFFF2FB300000000 AS DateTime), NULL)
/****** Object:  Table [dbo].[Questions]    Script Date: 05/09/2010 00:55:59 ******/
SET IDENTITY_INSERT [dbo].[Questions] ON
INSERT [dbo].[Questions] ([ID], [Title], [AuthorID], [Content], [CreateDate], [VoteUpCount], [VoteDownCount], [UpdateDate]) VALUES (43, N'Test question', N'f39661f2-a3bd-47a4-899f-38c71e35c738', N'Is this a test question?', CAST(0x00009D71000D5E47 AS DateTime), 1, 0, CAST(0x00009D71000D5E48 AS DateTime))
INSERT [dbo].[Questions] ([ID], [Title], [AuthorID], [Content], [CreateDate], [VoteUpCount], [VoteDownCount], [UpdateDate]) VALUES (44, N'another question ', N'f39661f2-a3bd-47a4-899f-38c71e35c738', N'And this one. is this one a question?', CAST(0x00009D71000D8537 AS DateTime), 0, 0, CAST(0x00009D71000D8537 AS DateTime))
INSERT [dbo].[Questions] ([ID], [Title], [AuthorID], [Content], [CreateDate], [VoteUpCount], [VoteDownCount], [UpdateDate]) VALUES (45, N'question bu test 2', N'83666688-5998-45a8-82d4-28f517ae3945', N'this is my question? s it good?', CAST(0x00009D71000E9E12 AS DateTime), 0, 0, CAST(0x00009D71000E9E12 AS DateTime))
SET IDENTITY_INSERT [dbo].[Questions] OFF
/****** Object:  Table [dbo].[Answers]    Script Date: 05/09/2010 00:55:59 ******/
SET IDENTITY_INSERT [dbo].[Answers] ON
INSERT [dbo].[Answers] ([ID], [QuestionID], [AuthorID], [Content], [CreateDate], [IsCorrect], [VoteUpCount], [VoteDownCount], [UpdateDate]) VALUES (178, 44, N'f39661f2-a3bd-47a4-899f-38c71e35c738', N'I think it is!', CAST(0x00009D71000D9F47 AS DateTime), 0, 0, 0, CAST(0x00009D71000D9F47 AS DateTime))
INSERT [dbo].[Answers] ([ID], [QuestionID], [AuthorID], [Content], [CreateDate], [IsCorrect], [VoteUpCount], [VoteDownCount], [UpdateDate]) VALUES (179, 44, N'83666688-5998-45a8-82d4-28f517ae3945', N'yep!', CAST(0x00009D71000E0BE4 AS DateTime), 0, 0, 0, CAST(0x00009D71000E0BE4 AS DateTime))
INSERT [dbo].[Answers] ([ID], [QuestionID], [AuthorID], [Content], [CreateDate], [IsCorrect], [VoteUpCount], [VoteDownCount], [UpdateDate]) VALUES (180, 43, N'83666688-5998-45a8-82d4-28f517ae3945', N'no it isn''t.', CAST(0x00009D71000EB9C4 AS DateTime), 1, 0, 0, CAST(0x00009D71000EB9C4 AS DateTime))
INSERT [dbo].[Answers] ([ID], [QuestionID], [AuthorID], [Content], [CreateDate], [IsCorrect], [VoteUpCount], [VoteDownCount], [UpdateDate]) VALUES (181, 43, N'83666688-5998-45a8-82d4-28f517ae3945', N'ot maybe it is....', CAST(0x00009D71000EC57A AS DateTime), 0, 1, 0, CAST(0x00009D71000EC57A AS DateTime))
SET IDENTITY_INSERT [dbo].[Answers] OFF
/****** Object:  Table [dbo].[FavouriteQuestions]    Script Date: 05/09/2010 00:55:59 ******/
INSERT [dbo].[FavouriteQuestions] ([QuestionID], [UserID]) VALUES (44, N'83666688-5998-45a8-82d4-28f517ae3945')
INSERT [dbo].[FavouriteQuestions] ([QuestionID], [UserID]) VALUES (44, N'f39661f2-a3bd-47a4-899f-38c71e35c738')
/****** Object:  Table [dbo].[QuestionVotes]    Script Date: 05/09/2010 00:55:59 ******/
INSERT [dbo].[QuestionVotes] ([QuestionID], [UserID], [VoteValue], [CreateDate]) VALUES (43, N'83666688-5998-45a8-82d4-28f517ae3945', 1, CAST(0x00009D71000EC8E7 AS DateTime))
/****** Object:  Table [dbo].[AnswerVotes]    Script Date: 05/09/2010 00:55:59 ******/
INSERT [dbo].[AnswerVotes] ([UserID], [AnswerID], [CreateDate], [VoteValue]) VALUES (N'f39661f2-a3bd-47a4-899f-38c71e35c738', 181, CAST(0x00009D71000F087C AS DateTime), 1)
/****** Object:  Table [dbo].[UserDetails]    Script Date: 05/09/2010 00:55:59 ******/
INSERT [dbo].[UserDetails] ([UserID], [FirstName], [LastName], [UpdateDate], [UserRating]) VALUES (N'83666688-5998-45a8-82d4-28f517ae3945', N'second', N'user', CAST(0x00009CF100000000 AS DateTime), 100)
INSERT [dbo].[UserDetails] ([UserID], [FirstName], [LastName], [UpdateDate], [UserRating]) VALUES (N'f39661f2-a3bd-47a4-899f-38c71e35c738', N'first', N'user', CAST(0x00008EAC00000000 AS DateTime), 100)
/****** Object:  Table [dbo].[aspnet_PersonalizationPerUser]    Script Date: 05/09/2010 00:55:59 ******/
/****** Object:  Table [dbo].[aspnet_Profile]    Script Date: 05/09/2010 00:55:59 ******/
/****** Object:  Table [dbo].[aspnet_UsersInRoles]    Script Date: 05/09/2010 00:55:59 ******/
INSERT [dbo].[aspnet_UsersInRoles] ([UserId], [RoleId]) VALUES (N'83666688-5998-45a8-82d4-28f517ae3945', N'f59cc23f-64ba-4f24-a082-27b3a6e0a0ce')
INSERT [dbo].[aspnet_UsersInRoles] ([UserId], [RoleId]) VALUES (N'f39661f2-a3bd-47a4-899f-38c71e35c738', N'f59cc23f-64ba-4f24-a082-27b3a6e0a0ce')
/****** Object:  Table [dbo].[aspnet_PersonalizationAllUsers]    Script Date: 05/09/2010 00:55:59 ******/
